﻿select * from Artists

select * from Genres

select * from Albums

insert into Artists (Name,Description) values ('Jezz','Is Jazz')
insert into Artists (Name,Description) values ('Wang_j','Is Wang_j')
insert into Artists (Name,Description) values ('Lao_h','Is Lao_h')
insert into Artists (Name,Description) values ('Xiao_x','Is Xiao_x ')
insert into Artists (Name,Description) values ('小俊','Is Xiao_jun')

update Artists set Name = 'Jezz' where Id=1

insert into Genres (Name) values ('Pastoral poetry school')
insert into Genres (Name) values ('frontier poetry school')
insert into Genres (Name) values ('Jiangxi poetry school')
insert into Genres (Name) values ('Xiangshan nine old')
insert into Genres (Name) values ('root seeking literature')
insert into Genres (Name) values ('postwar school')
insert into Genres (Name) values ('new art school')

alter database "MusicStoreDB-20200513120436" set single_user with rollback  immediate ;
go
alter database "MusicStoreDB-20200513120436" collate Chinese_PRC_CI_AS ;
go
alter database "MusicStoreDB-20200513120436"  set multi_user;